package org.lzy.aibg.mapper;

import org.lzy.aibg.pojo.Employee;

import java.util.List;

public interface EmployeeMapper {
    List<Employee> selectAll();
    Employee selectById(Integer empId);
    //根据传入的参数对员工列表进行排序，desc asc
    List<Employee> selectByOrder(String order);
    //通过姓名查询员工
    List<Employee> selectByName(String name);
    //通过性别来查询员工
    List<Employee> selectByGender(String gender);
    //根据姓名查找员工并用性别排序
    List<Employee> selectByNameOrderByGender(String name,String order);
}